CREATE TABLE [dbo].[RelationshipTypeCategory]
(
[RelationshipTypeCategoryKey] [uniqueidentifier] NOT NULL,
[RelationshipTypeKey] [uniqueidentifier] NOT NULL,
[RelationshipCategoryKey] [uniqueidentifier] NOT NULL,
[IsSystem] [bit] NOT NULL,
[IsActive] [bit] NOT NULL,
[MarkedForDeleteOn] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[RelationshipTypeCategory] ADD CONSTRAINT [PK_RelationshipTypeCategory] PRIMARY KEY CLUSTERED ([RelationshipTypeCategoryKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RelationshipTypeCategory] ADD CONSTRAINT [AK_RelationshipTypeCategory] UNIQUE NONCLUSTERED ([RelationshipTypeKey], [RelationshipCategoryKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RelationshipTypeCategory] ADD CONSTRAINT [FK_RelationshipTypeCategory_RelationshipCategoryRef] FOREIGN KEY ([RelationshipCategoryKey]) REFERENCES [dbo].[RelationshipCategoryRef] ([RelationshipCategoryKey])
GO
ALTER TABLE [dbo].[RelationshipTypeCategory] ADD CONSTRAINT [FK_RelationshipTypeCategory_RelationshipTypeRef] FOREIGN KEY ([RelationshipTypeKey]) REFERENCES [dbo].[RelationshipTypeRef] ([RelationshipTypeKey])
GO